Member filtering – load from MS Excel

Find member has special feature to load criteria from file:

 

·            Right click selected level (our case Customer)

·            Select Find members … from menu

 

 

Dialog will appear:

 

 

 

§          Select button Import

 

 

·          Select Select file button

·          Select appropriate version of Excel

·          Navigate to file where your criteria have been saved

 

 

·          Select Open button

 

 

·          Select Import

 

 

                NOTE: Criteria saved in MS Excel file MUST be saved in first (A) column

 

·          Select OK

 

 

All of your saved criteria are loaded. Sign for OR logical function is “||” (double pipe).

 

·            Select OK

 

 

Now you can reduce your selection or select all of them.

After that select

 

·            Select OK

 

Selected members will be visible inside cube browser.

 

 

To add all of them to the row or column area:

 

·            Right click one of them

·            Select Add all members to

·            Select one of areas